UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'an4S0LC4FSzifaX/0DUnVOqQGV5ADVbd5douTeD4Io0='
WHERE
key_id = 'd9707c25304d27ee259b0afe768455e1cadafe3e3cff0b7023f24a3bb98c2575'
AND (
token = 'an4S0LC4FSzifaX/0DUnVOqQGV5ADVbd5douTeD4Io0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)