UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6RRvvj/ON4lVt/YzL9vPpvOxg2KRY8Np6mijZsVijo='
WHERE
key_id = '04f1ceccf127d6e0597f329a53c2f5caf0da6f6e212ba20c87d8705456cc7205'
AND (
token = '+6RRvvj/ON4lVt/YzL9vPpvOxg2KRY8Np6mijZsVijo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)