UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKeoZaPcaE6jga7HMB59Qkf12IAcsjj9Wdt6i7SfXzU='
WHERE
key_id = '6e441eada9217694f8e28db663efc1b2604662b4bbf05ba4459b4aa89f3a9fb2'
AND (
token = 'BKeoZaPcaE6jga7HMB59Qkf12IAcsjj9Wdt6i7SfXzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)