UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NJ/oKIdw332WJOrkGUV2oasRvajN4+nGLXrgRjxrAY='
WHERE
key_id = 'ac7decea6af2deaca8224ac7ac6c3f19c0bf0bd8da5be4a9b997a0089c50207c'
AND (
token = '8NJ/oKIdw332WJOrkGUV2oasRvajN4+nGLXrgRjxrAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)