UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WguSmMgSQFoT1BqNmeChkECtKOyzSwmwwsF4xrExWcA='
WHERE
key_id = '7de4c327c523d6c3793f18fa99515c2a7652a6563486f8f11647eacab2094ba4'
AND (
token = 'WguSmMgSQFoT1BqNmeChkECtKOyzSwmwwsF4xrExWcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)