UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64KV2CvgxSfHzwqWTgqGLGRuDJWoOX04s/a8HT2/UAk='
WHERE
key_id = '4c39f722cfbe09571b0968ac481df05457e52f4c88a17c79d26437808861bf97'
AND (
token = '64KV2CvgxSfHzwqWTgqGLGRuDJWoOX04s/a8HT2/UAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)