UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzXyxWT7EqBDbUA3lsVtRotp3BlRzmk/2IV66cKb8Tw='
WHERE
key_id = 'd77f6b333dd05ac1d3072d8cc73b80c5e29d551fd1da089ee3d2ef68721fd1a3'
AND (
token = 'CzXyxWT7EqBDbUA3lsVtRotp3BlRzmk/2IV66cKb8Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)