UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihCZoznDrN+sNXnhisHjBVasgy122ufIt7bc/ZRLFAs='
WHERE
key_id = '28e0edb83ae81aed789db8f67ac9eba3a32311d125710a9f2370015a76139ac2'
AND (
token = 'ihCZoznDrN+sNXnhisHjBVasgy122ufIt7bc/ZRLFAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)