UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x4k5H0r7djnHzh/mdhHbT1pTMtfKodcmW2wdiDa1vGw='
WHERE
key_id = 'acbc07ce3f380424daf080b87e1ab221df8fca652d28cf2e80057eab14eab4d2'
AND (
token = 'x4k5H0r7djnHzh/mdhHbT1pTMtfKodcmW2wdiDa1vGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)