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