UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BJCVuV7YKhYQcA2kxEDruHUsIWNaA5+T46aHAiUXCg='
WHERE
key_id = '0ab0461fcea786739b30c6354d1968a3863bf7089342a878e253c05332eeab87'
AND (
token = '6BJCVuV7YKhYQcA2kxEDruHUsIWNaA5+T46aHAiUXCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)