UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+yp8HNLsxmqwSEBMEcell1ECuFDCx1zos2EQgutxTE='
WHERE
key_id = 'c0d666aca7e6f629a64005497dc74de81877009ecc1d25155bf6a193375ca39b'
AND (
token = '7+yp8HNLsxmqwSEBMEcell1ECuFDCx1zos2EQgutxTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)