UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKRUVFFnvHDrkwhleyVTUYkIO9aarzP/cigqWlugUYg='
WHERE
key_id = '2aefd53cbc8c9d694cde597e94b8985b1a2d6093930b2e0c85010cee52b7429e'
AND (
token = 'cKRUVFFnvHDrkwhleyVTUYkIO9aarzP/cigqWlugUYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)