UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lhq1tR08B1ELhZvQ75w97lGVzcGbHHcWtkXLubuCwvo='
WHERE
key_id = 'f4c6a4f5c3145132b0b62cfabb99382ac0f417eb45f55a9071e56b5dba6c3278'
AND (
token = 'lhq1tR08B1ELhZvQ75w97lGVzcGbHHcWtkXLubuCwvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)