UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhyKOVJ+cn8ezugrItmznniMrKlo/WjXUEFDDU3tHmw='
WHERE
key_id = 'be3cefca747c3a0fda9dd72e0550c5082469282171d28eedd6a246b977b7620f'
AND (
token = 'BhyKOVJ+cn8ezugrItmznniMrKlo/WjXUEFDDU3tHmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)