UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uCdxhgnMMAzTxhDFCbO22ZWKVsixr0jwZFdXqb0vjag='
WHERE
key_id = 'cace8da033a1e7dcbcb6e44c3f3f6c2549d13e25a09673c05592c8a5e3dbe2d9'
AND (
token = 'uCdxhgnMMAzTxhDFCbO22ZWKVsixr0jwZFdXqb0vjag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)