UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rR3wt3fJkkDYiU19FwyjOAGhsCqKEbUTnVc46ZMi0i8='
WHERE
key_id = '9660f9453f425fff661e2a9491f38723b1202aa9af9d66a93249a054864ca7c1'
AND (
token = 'rR3wt3fJkkDYiU19FwyjOAGhsCqKEbUTnVc46ZMi0i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)