UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtRcPDcS2SPag5E8Gi9dvyULaqrGtKRIO0mD6YUUIn8='
WHERE
key_id = 'e9f1fef745079809ae0bcece9a3ea720f494d9d708a1df7cbe935966901c1658'
AND (
token = 'CtRcPDcS2SPag5E8Gi9dvyULaqrGtKRIO0mD6YUUIn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)