UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7yj/GfXblChvRfpqfxTQCsKOkvWYunnpSwpFqUAdYs='
WHERE
key_id = 'e04a0468b6155f051abeb9c0b75518f95b51b0f54957f8e36964ad37ec1d5ae3'
AND (
token = 'i7yj/GfXblChvRfpqfxTQCsKOkvWYunnpSwpFqUAdYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)