UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oQb68RKTJGyJqpuyKzhgsUj3jO/SubX7hvjkXGuoLj0='
WHERE
key_id = 'bd27afb5b47926569383aff790744744c41108c31c3940d225c6bf6acc43136c'
AND (
token = 'oQb68RKTJGyJqpuyKzhgsUj3jO/SubX7hvjkXGuoLj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)