UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6pfJhu7dzLGmv0Agt2ZB+bnI3UODzknHrqHXeJpf0k='
WHERE
key_id = 'bb7e87b32162be38a8fb4922e2ca6dd15b77d8c66ebc52b2bea91ba3a4b05fa3'
AND (
token = 'S6pfJhu7dzLGmv0Agt2ZB+bnI3UODzknHrqHXeJpf0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)