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