UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SL4bscfOHekhD9bc0+vPKqc+TcWF4y1eajWlIXfK/S8='
WHERE
key_id = 'c787b66755cb60a807b89f2984d8a522b423d833af0523a643d3170c622a44f3'
AND (
token = 'SL4bscfOHekhD9bc0+vPKqc+TcWF4y1eajWlIXfK/S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)