UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hvl5e7q42nWz4NGQ+TU0PwG+DL/iJxJu37lpEddJV18='
WHERE
key_id = 'c628b54fc9fd0085b0158b255a22800c0a9515de5e842568c840a5312ff38226'
AND (
token = 'hvl5e7q42nWz4NGQ+TU0PwG+DL/iJxJu37lpEddJV18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)