UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFCn4h4CT4WaLDazJ6+1vo72sQHNsef9TJcbyQhoRXM='
WHERE
key_id = 'c7a8c8e74f20b822cf5e18f078437b440e213751067b7f2575344f7a23a12778'
AND (
token = 'ZFCn4h4CT4WaLDazJ6+1vo72sQHNsef9TJcbyQhoRXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)