UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RRYPE47J5DslHRL3dKC4oHK34oIWvxk78mzFb3CfwPg='
WHERE
key_id = '8f5b4b50894f8eb527abca602a204fa9cfdd9c70b8dace6aac680ba20bc0ce5e'
AND (
token = 'RRYPE47J5DslHRL3dKC4oHK34oIWvxk78mzFb3CfwPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)