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