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