UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8fH7c2Q3A5cg2EGn6WkZqHHLzmvn8vE5pNHjN1KgmU='
WHERE
key_id = 'b3711b88c2199f321db801d04ec20317efeeb3c8afd0aa7077156259d9464740'
AND (
token = 'S8fH7c2Q3A5cg2EGn6WkZqHHLzmvn8vE5pNHjN1KgmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)