UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XptMb4eXnmdxmA5qLMnYJOlrYGD+0A7gt0dQogv1o0='
WHERE
key_id = '6c851361e62b5d11ad905e85f5583a00a8b16570be9d3e444dd86f06b341f4ac'
AND (
token = '/XptMb4eXnmdxmA5qLMnYJOlrYGD+0A7gt0dQogv1o0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)