UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5VtN0jdMHU82tjeyYOEwsWW+tfnTBe/gbHyM9IKOviA='
WHERE
key_id = '1d52013205c43927fbc821ccbfef8291260ebd3667b596638f483a34e1a3c186'
AND (
token = '5VtN0jdMHU82tjeyYOEwsWW+tfnTBe/gbHyM9IKOviA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)