UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZIFg8NZ5uMJWca4+pbNV1uIaWWRyFnr0XCOorHoREA='
WHERE
key_id = 'cac9b9c40cef795ea8f69f99e6f41f046617d92e93ad726d02512afcf3cf742d'
AND (
token = 'zZIFg8NZ5uMJWca4+pbNV1uIaWWRyFnr0XCOorHoREA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)