UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3tuB06WhGxwJYKpoPEGnztIsM7b9pFFLlDsmSuu5UyA='
WHERE
key_id = '0258f67aa94f8d6e5845745a324c5dba2334d358f2e6d02796bd734fe9ff4af5'
AND (
token = '3tuB06WhGxwJYKpoPEGnztIsM7b9pFFLlDsmSuu5UyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)