UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQgCizWLo+XUJV5fqp5IiyZkNfdv/fxvtd7328YmIXs='
WHERE
key_id = '09fc298e21134dfc81e8dbd19d5e7cc7230b92f2b3d0c0fc5bef25636d03a6a4'
AND (
token = 'XQgCizWLo+XUJV5fqp5IiyZkNfdv/fxvtd7328YmIXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)