UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mfTFYzJxWHLFScdzgyOS6bxjqGwHah41oGH7wqJvScA='
WHERE
key_id = '6110a597f565d79554c1d902854827568807f79f02782939593d810490972d20'
AND (
token = 'mfTFYzJxWHLFScdzgyOS6bxjqGwHah41oGH7wqJvScA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)