UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lplSN2KGxaeGKI2HD8D2pMASLkEhLB6jCAycC0aNqY8='
WHERE
key_id = '47f00fcbaf2a32809058ba557c4dcc1d37481f04e2cea6937967a185bf4f3c3d'
AND (
token = 'lplSN2KGxaeGKI2HD8D2pMASLkEhLB6jCAycC0aNqY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)