UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5k3G++QvYjAhmcOI7VvaNj8ty95l9ayweKlVurjXJCg='
WHERE
key_id = '31dc731eb939ee63d433e8be3aabcd88762c77cf196cc9411eb9e6ea79872606'
AND (
token = '5k3G++QvYjAhmcOI7VvaNj8ty95l9ayweKlVurjXJCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)