UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v20R+D+vt0TyQHi9ZiX2Rl88oOuo52WNVfI541/zqHs='
WHERE
key_id = '397c6a85358beef80fb308af2d0617173cd12e2e9ee922077fe3230b3f960b99'
AND (
token = 'v20R+D+vt0TyQHi9ZiX2Rl88oOuo52WNVfI541/zqHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)