UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nUio4PNa+P2llEG9W6xb8QjCBNd8kL8HEOs+9Mgwdz4='
WHERE
key_id = '4aae8e96ab7972ea1a35fb3f216000d5d0693f3ba156dffea2ea07d9d435bbbb'
AND (
token = 'nUio4PNa+P2llEG9W6xb8QjCBNd8kL8HEOs+9Mgwdz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)