UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYDpb1XUd9EYih0D9HtQVbyBYj/mbTcPyFQPt8XKkqw='
WHERE
key_id = 'db27d876f2ded82b70fd4d61aef27885757d770d4b023ed521434d35b31d78d3'
AND (
token = 'XYDpb1XUd9EYih0D9HtQVbyBYj/mbTcPyFQPt8XKkqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)