UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJFTp7s4CG9/ckgkjIqUlSE5Sc4hN7IhEvHZn5KGg30='
WHERE
key_id = 'd4af0a673222cb649a08bd676df2da8c55f1fccca97a14c453bbd48c15250a85'
AND (
token = 'NJFTp7s4CG9/ckgkjIqUlSE5Sc4hN7IhEvHZn5KGg30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)