UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1qGlTGiLoFEWB+v/r7dfct+gG2MXnr1PNES1hm3kAUM='
WHERE
key_id = 'ade319319353335b3b40e97fd5251badf6249f97c482ff5f19cfd938f400af12'
AND (
token = '1qGlTGiLoFEWB+v/r7dfct+gG2MXnr1PNES1hm3kAUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)